| Key Name |
Key Type |
Keys |
| SaStudSubsidiaryTrans_AdTermID_SaStudSubsidiaryTransID_U_N_IDX |
Alternate Key |
TermId, StudentSubsidiaryAccountTransactionId |
| SaStudSubsidiaryTrans_SaStudSubsidiaryID_SaStudSubsidiaryTransID_U_N_IDX |
Alternate Key |
StudentSubsidiaryAccountId, StudentSubsidiaryAccountTransactionId |
| SaStudSubsidiaryTrans_SaSubsidiaryRefundID_SaStudSubsidiaryTransID_U_N_IDX |
Alternate Key |
StudentSubsidiaryAccountRefundId, StudentSubsidiaryAccountTransactionId |
| SaStudSubsidiaryTrans_SaCCID_N_N_IDX |
Inversion Entry |
StudentCreditCardId |
| SaStudSubsidiaryTrans_SaCashDrawerSessionID_N_N_IDX |
Inversion Entry |
CashDrawerSessionId |
| SaStudSubsidiaryTrans_SaBillCodeID_N_N_IDX |
Inversion Entry |
BillingTransactionCodeId |
| SaStudSubsidiaryTrans_SaBankDepID_N_N_IDX |
Inversion Entry |
BankDepositId |
| SaStudSubsidiaryTrans_SaStudSubsidiaryTransID_U_C_IDX |
PrimaryKey |
StudentSubsidiaryAccountTransactionId |
| SaStudSubsidiaryTrans_SaBankAccountID_N_N_IDX |
Inversion Entry |
BankAccountId |
| SaStudSubsidiaryTrans_SyAddressID_N_N_IDX |
Inversion Entry |
StudentRelationshipAddressId |
| SaStudSubsidiaryTrans_UserID_SaStudSubsidiaryTransID_U_N_IDX |
Alternate Key |
LastModifiedUserId, StudentSubsidiaryAccountTransactionId |
| SaStudSubsidiaryTrans_SyCampusID_SaStudSubsidiaryTransID_U_N_IDX |
Alternate Key |
CampusId, StudentSubsidiaryAccountTransactionId |
| Entity Name |
Type |
Cardinality |
Business Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
| BankAccount |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BankAccountId |
NO |
| BankDeposit |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BankDepositId |
NO |
| BillingTransactionCode |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BillingTransactionCodeId |
NO |
| Campus |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CampusId |
NO |
| CashDrawerSession |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CashDrawerSessionId |
NO |
| Term |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TermId |
NO |
| BankAccount |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BankAccountId |
NO |
| BankDeposit |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BankDepositId |
NO |
| BillingTransactionCode |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BillingTransactionCodeId |
NO |
| CashDrawerSession |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CashDrawerSessionId |
NO |
| StudentCreditCard |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentCreditCardId |
NO |
| StudentSubsidiaryAccount |
Non-Identifying |
One To Zero or More |
|
|
|
StudentSubsidiaryAccountId |
NO |
| StudentSubsidiaryAccountRefund |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentSubsidiaryAccountRefundId |
NO |
| StudentRelationshipAddress |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentRelationshipAddressId |
NO |
| Campus |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CampusId |
NO |
| Staff |
Non-Identifying |
One To Zero or More |
|
|
|
LastModifiedUserId |
NO |
| StudentCreditCard |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentCreditCardId |
NO |
| StudentRelationshipAddress |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentRelationshipAddressId |
NO |
| StudentSubsidiaryAccount |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentSubsidiaryAccountId |
NO |
| StudentSubsidiaryAccountRefund |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentSubsidiaryAccountRefundId |
NO |
| Term |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
TermId |
NO |